package com.health.db.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class UserContactLISTExample extends UserContactLIST {
    /**
	 * 
	 */
	private static final long serialVersionUID = -1655968242050455709L;

	protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UserContactLISTExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRecidIsNull() {
            addCriterion("RecID is null");
            return (Criteria) this;
        }

        public Criteria andRecidIsNotNull() {
            addCriterion("RecID is not null");
            return (Criteria) this;
        }

        public Criteria andRecidEqualTo(Long value) {
            addCriterion("RecID =", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotEqualTo(Long value) {
            addCriterion("RecID <>", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThan(Long value) {
            addCriterion("RecID >", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThanOrEqualTo(Long value) {
            addCriterion("RecID >=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThan(Long value) {
            addCriterion("RecID <", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThanOrEqualTo(Long value) {
            addCriterion("RecID <=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidIn(List<Long> values) {
            addCriterion("RecID in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotIn(List<Long> values) {
            addCriterion("RecID not in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidBetween(Long value1, Long value2) {
            addCriterion("RecID between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotBetween(Long value1, Long value2) {
            addCriterion("RecID not between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNull() {
            addCriterion("systemID is null");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNotNull() {
            addCriterion("systemID is not null");
            return (Criteria) this;
        }

        public Criteria andSystemidEqualTo(Integer value) {
            addCriterion("systemID =", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotEqualTo(Integer value) {
            addCriterion("systemID <>", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThan(Integer value) {
            addCriterion("systemID >", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("systemID >=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThan(Integer value) {
            addCriterion("systemID <", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThanOrEqualTo(Integer value) {
            addCriterion("systemID <=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidIn(List<Integer> values) {
            addCriterion("systemID in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotIn(List<Integer> values) {
            addCriterion("systemID not in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidBetween(Integer value1, Integer value2) {
            addCriterion("systemID between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotBetween(Integer value1, Integer value2) {
            addCriterion("systemID not between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andContactidIsNull() {
            addCriterion("ContactID is null");
            return (Criteria) this;
        }

        public Criteria andContactidIsNotNull() {
            addCriterion("ContactID is not null");
            return (Criteria) this;
        }

        public Criteria andContactidEqualTo(Long value) {
            addCriterion("ContactID =", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidNotEqualTo(Long value) {
            addCriterion("ContactID <>", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidGreaterThan(Long value) {
            addCriterion("ContactID >", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidGreaterThanOrEqualTo(Long value) {
            addCriterion("ContactID >=", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidLessThan(Long value) {
            addCriterion("ContactID <", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidLessThanOrEqualTo(Long value) {
            addCriterion("ContactID <=", value, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidIn(List<Long> values) {
            addCriterion("ContactID in", values, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidNotIn(List<Long> values) {
            addCriterion("ContactID not in", values, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidBetween(Long value1, Long value2) {
            addCriterion("ContactID between", value1, value2, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactidNotBetween(Long value1, Long value2) {
            addCriterion("ContactID not between", value1, value2, "contactid");
            return (Criteria) this;
        }

        public Criteria andContactNameIsNull() {
            addCriterion("Contact_NAME is null");
            return (Criteria) this;
        }

        public Criteria andContactNameIsNotNull() {
            addCriterion("Contact_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andContactNameEqualTo(String value) {
            addCriterion("Contact_NAME =", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotEqualTo(String value) {
            addCriterion("Contact_NAME <>", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameGreaterThan(String value) {
            addCriterion("Contact_NAME >", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameGreaterThanOrEqualTo(String value) {
            addCriterion("Contact_NAME >=", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameLessThan(String value) {
            addCriterion("Contact_NAME <", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameLessThanOrEqualTo(String value) {
            addCriterion("Contact_NAME <=", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameLike(String value) {
            addCriterion("Contact_NAME like", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotLike(String value) {
            addCriterion("Contact_NAME not like", value, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameIn(List<String> values) {
            addCriterion("Contact_NAME in", values, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotIn(List<String> values) {
            addCriterion("Contact_NAME not in", values, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameBetween(String value1, String value2) {
            addCriterion("Contact_NAME between", value1, value2, "contactName");
            return (Criteria) this;
        }

        public Criteria andContactNameNotBetween(String value1, String value2) {
            addCriterion("Contact_NAME not between", value1, value2, "contactName");
            return (Criteria) this;
        }

        public Criteria andSourceidIsNull() {
            addCriterion("SourceID is null");
            return (Criteria) this;
        }

        public Criteria andSourceidIsNotNull() {
            addCriterion("SourceID is not null");
            return (Criteria) this;
        }

        public Criteria andSourceidEqualTo(Integer value) {
            addCriterion("SourceID =", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidNotEqualTo(Integer value) {
            addCriterion("SourceID <>", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidGreaterThan(Integer value) {
            addCriterion("SourceID >", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidGreaterThanOrEqualTo(Integer value) {
            addCriterion("SourceID >=", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidLessThan(Integer value) {
            addCriterion("SourceID <", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidLessThanOrEqualTo(Integer value) {
            addCriterion("SourceID <=", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidIn(List<Integer> values) {
            addCriterion("SourceID in", values, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidNotIn(List<Integer> values) {
            addCriterion("SourceID not in", values, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidBetween(Integer value1, Integer value2) {
            addCriterion("SourceID between", value1, value2, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidNotBetween(Integer value1, Integer value2) {
            addCriterion("SourceID not between", value1, value2, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridIsNull() {
            addCriterion("SourceMasterID is null");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridIsNotNull() {
            addCriterion("SourceMasterID is not null");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridEqualTo(Long value) {
            addCriterion("SourceMasterID =", value, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridNotEqualTo(Long value) {
            addCriterion("SourceMasterID <>", value, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridGreaterThan(Long value) {
            addCriterion("SourceMasterID >", value, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridGreaterThanOrEqualTo(Long value) {
            addCriterion("SourceMasterID >=", value, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridLessThan(Long value) {
            addCriterion("SourceMasterID <", value, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridLessThanOrEqualTo(Long value) {
            addCriterion("SourceMasterID <=", value, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridIn(List<Long> values) {
            addCriterion("SourceMasterID in", values, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridNotIn(List<Long> values) {
            addCriterion("SourceMasterID not in", values, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridBetween(Long value1, Long value2) {
            addCriterion("SourceMasterID between", value1, value2, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andSourcemasteridNotBetween(Long value1, Long value2) {
            addCriterion("SourceMasterID not between", value1, value2, "sourcemasterid");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagIsNull() {
            addCriterion("is_default_Contact_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagIsNotNull() {
            addCriterion("is_default_Contact_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagEqualTo(Integer value) {
            addCriterion("is_default_Contact_FLAG =", value, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagNotEqualTo(Integer value) {
            addCriterion("is_default_Contact_FLAG <>", value, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagGreaterThan(Integer value) {
            addCriterion("is_default_Contact_FLAG >", value, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_default_Contact_FLAG >=", value, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagLessThan(Integer value) {
            addCriterion("is_default_Contact_FLAG <", value, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagLessThanOrEqualTo(Integer value) {
            addCriterion("is_default_Contact_FLAG <=", value, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagIn(List<Integer> values) {
            addCriterion("is_default_Contact_FLAG in", values, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagNotIn(List<Integer> values) {
            addCriterion("is_default_Contact_FLAG not in", values, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagBetween(Integer value1, Integer value2) {
            addCriterion("is_default_Contact_FLAG between", value1, value2, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultContactFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("is_default_Contact_FLAG not between", value1, value2, "isDefaultContactFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagIsNull() {
            addCriterion("is_default_Address_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagIsNotNull() {
            addCriterion("is_default_Address_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagEqualTo(Integer value) {
            addCriterion("is_default_Address_FLAG =", value, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagNotEqualTo(Integer value) {
            addCriterion("is_default_Address_FLAG <>", value, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagGreaterThan(Integer value) {
            addCriterion("is_default_Address_FLAG >", value, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_default_Address_FLAG >=", value, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagLessThan(Integer value) {
            addCriterion("is_default_Address_FLAG <", value, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagLessThanOrEqualTo(Integer value) {
            addCriterion("is_default_Address_FLAG <=", value, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagIn(List<Integer> values) {
            addCriterion("is_default_Address_FLAG in", values, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagNotIn(List<Integer> values) {
            addCriterion("is_default_Address_FLAG not in", values, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagBetween(Integer value1, Integer value2) {
            addCriterion("is_default_Address_FLAG between", value1, value2, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andIsDefaultAddressFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("is_default_Address_FLAG not between", value1, value2, "isDefaultAddressFlag");
            return (Criteria) this;
        }

        public Criteria andImidIsNull() {
            addCriterion("IMid is null");
            return (Criteria) this;
        }

        public Criteria andImidIsNotNull() {
            addCriterion("IMid is not null");
            return (Criteria) this;
        }

        public Criteria andImidEqualTo(String value) {
            addCriterion("IMid =", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidNotEqualTo(String value) {
            addCriterion("IMid <>", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidGreaterThan(String value) {
            addCriterion("IMid >", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidGreaterThanOrEqualTo(String value) {
            addCriterion("IMid >=", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidLessThan(String value) {
            addCriterion("IMid <", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidLessThanOrEqualTo(String value) {
            addCriterion("IMid <=", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidLike(String value) {
            addCriterion("IMid like", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidNotLike(String value) {
            addCriterion("IMid not like", value, "imid");
            return (Criteria) this;
        }

        public Criteria andImidIn(List<String> values) {
            addCriterion("IMid in", values, "imid");
            return (Criteria) this;
        }

        public Criteria andImidNotIn(List<String> values) {
            addCriterion("IMid not in", values, "imid");
            return (Criteria) this;
        }

        public Criteria andImidBetween(String value1, String value2) {
            addCriterion("IMid between", value1, value2, "imid");
            return (Criteria) this;
        }

        public Criteria andImidNotBetween(String value1, String value2) {
            addCriterion("IMid not between", value1, value2, "imid");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("eMail is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("eMail is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("eMail =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("eMail <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("eMail >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("eMail >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("eMail <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("eMail <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("eMail like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("eMail not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("eMail in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("eMail not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("eMail between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("eMail not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNull() {
            addCriterion("TelePhone is null");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNotNull() {
            addCriterion("TelePhone is not null");
            return (Criteria) this;
        }

        public Criteria andTelephoneEqualTo(String value) {
            addCriterion("TelePhone =", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotEqualTo(String value) {
            addCriterion("TelePhone <>", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThan(String value) {
            addCriterion("TelePhone >", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("TelePhone >=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThan(String value) {
            addCriterion("TelePhone <", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThanOrEqualTo(String value) {
            addCriterion("TelePhone <=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLike(String value) {
            addCriterion("TelePhone like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotLike(String value) {
            addCriterion("TelePhone not like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneIn(List<String> values) {
            addCriterion("TelePhone in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotIn(List<String> values) {
            addCriterion("TelePhone not in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneBetween(String value1, String value2) {
            addCriterion("TelePhone between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotBetween(String value1, String value2) {
            addCriterion("TelePhone not between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneIsNull() {
            addCriterion("mobilePhone is null");
            return (Criteria) this;
        }

        public Criteria andMobilephoneIsNotNull() {
            addCriterion("mobilePhone is not null");
            return (Criteria) this;
        }

        public Criteria andMobilephoneEqualTo(String value) {
            addCriterion("mobilePhone =", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneNotEqualTo(String value) {
            addCriterion("mobilePhone <>", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneGreaterThan(String value) {
            addCriterion("mobilePhone >", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneGreaterThanOrEqualTo(String value) {
            addCriterion("mobilePhone >=", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneLessThan(String value) {
            addCriterion("mobilePhone <", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneLessThanOrEqualTo(String value) {
            addCriterion("mobilePhone <=", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneLike(String value) {
            addCriterion("mobilePhone like", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneNotLike(String value) {
            addCriterion("mobilePhone not like", value, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneIn(List<String> values) {
            addCriterion("mobilePhone in", values, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneNotIn(List<String> values) {
            addCriterion("mobilePhone not in", values, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneBetween(String value1, String value2) {
            addCriterion("mobilePhone between", value1, value2, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andMobilephoneNotBetween(String value1, String value2) {
            addCriterion("mobilePhone not between", value1, value2, "mobilephone");
            return (Criteria) this;
        }

        public Criteria andSmsidIsNull() {
            addCriterion("SMSid is null");
            return (Criteria) this;
        }

        public Criteria andSmsidIsNotNull() {
            addCriterion("SMSid is not null");
            return (Criteria) this;
        }

        public Criteria andSmsidEqualTo(String value) {
            addCriterion("SMSid =", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidNotEqualTo(String value) {
            addCriterion("SMSid <>", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidGreaterThan(String value) {
            addCriterion("SMSid >", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidGreaterThanOrEqualTo(String value) {
            addCriterion("SMSid >=", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidLessThan(String value) {
            addCriterion("SMSid <", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidLessThanOrEqualTo(String value) {
            addCriterion("SMSid <=", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidLike(String value) {
            addCriterion("SMSid like", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidNotLike(String value) {
            addCriterion("SMSid not like", value, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidIn(List<String> values) {
            addCriterion("SMSid in", values, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidNotIn(List<String> values) {
            addCriterion("SMSid not in", values, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidBetween(String value1, String value2) {
            addCriterion("SMSid between", value1, value2, "smsid");
            return (Criteria) this;
        }

        public Criteria andSmsidNotBetween(String value1, String value2) {
            addCriterion("SMSid not between", value1, value2, "smsid");
            return (Criteria) this;
        }

        public Criteria andZipcodeIsNull() {
            addCriterion("ZIPCODE is null");
            return (Criteria) this;
        }

        public Criteria andZipcodeIsNotNull() {
            addCriterion("ZIPCODE is not null");
            return (Criteria) this;
        }

        public Criteria andZipcodeEqualTo(Integer value) {
            addCriterion("ZIPCODE =", value, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeNotEqualTo(Integer value) {
            addCriterion("ZIPCODE <>", value, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeGreaterThan(Integer value) {
            addCriterion("ZIPCODE >", value, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ZIPCODE >=", value, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeLessThan(Integer value) {
            addCriterion("ZIPCODE <", value, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeLessThanOrEqualTo(Integer value) {
            addCriterion("ZIPCODE <=", value, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeIn(List<Integer> values) {
            addCriterion("ZIPCODE in", values, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeNotIn(List<Integer> values) {
            addCriterion("ZIPCODE not in", values, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeBetween(Integer value1, Integer value2) {
            addCriterion("ZIPCODE between", value1, value2, "zipcode");
            return (Criteria) this;
        }

        public Criteria andZipcodeNotBetween(Integer value1, Integer value2) {
            addCriterion("ZIPCODE not between", value1, value2, "zipcode");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("FAX is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("FAX is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("FAX =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("FAX <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("FAX >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("FAX >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("FAX <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("FAX <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("FAX like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("FAX not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("FAX in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("FAX not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("FAX between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("FAX not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIsNull() {
            addCriterion("is_Used_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIsNotNull() {
            addCriterion("is_Used_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagEqualTo(Integer value) {
            addCriterion("is_Used_FLAG =", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotEqualTo(Integer value) {
            addCriterion("is_Used_FLAG <>", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagGreaterThan(Integer value) {
            addCriterion("is_Used_FLAG >", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_Used_FLAG >=", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagLessThan(Integer value) {
            addCriterion("is_Used_FLAG <", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagLessThanOrEqualTo(Integer value) {
            addCriterion("is_Used_FLAG <=", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIn(List<Integer> values) {
            addCriterion("is_Used_FLAG in", values, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotIn(List<Integer> values) {
            addCriterion("is_Used_FLAG not in", values, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagBetween(Integer value1, Integer value2) {
            addCriterion("is_Used_FLAG between", value1, value2, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("is_Used_FLAG not between", value1, value2, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andCommentIsNull() {
            addCriterion("comment is null");
            return (Criteria) this;
        }

        public Criteria andCommentIsNotNull() {
            addCriterion("comment is not null");
            return (Criteria) this;
        }

        public Criteria andCommentEqualTo(String value) {
            addCriterion("comment =", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotEqualTo(String value) {
            addCriterion("comment <>", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThan(String value) {
            addCriterion("comment >", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThanOrEqualTo(String value) {
            addCriterion("comment >=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThan(String value) {
            addCriterion("comment <", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThanOrEqualTo(String value) {
            addCriterion("comment <=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLike(String value) {
            addCriterion("comment like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotLike(String value) {
            addCriterion("comment not like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentIn(List<String> values) {
            addCriterion("comment in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotIn(List<String> values) {
            addCriterion("comment not in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentBetween(String value1, String value2) {
            addCriterion("comment between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotBetween(String value1, String value2) {
            addCriterion("comment not between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("update_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("update_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("update_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("update_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("update_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("update_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("update_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("update_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("update_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("update_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("update_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("update_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNull() {
            addCriterion("update_UserID is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNotNull() {
            addCriterion("update_UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridEqualTo(Long value) {
            addCriterion("update_UserID =", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotEqualTo(Long value) {
            addCriterion("update_UserID <>", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThan(Long value) {
            addCriterion("update_UserID >", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("update_UserID >=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThan(Long value) {
            addCriterion("update_UserID <", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThanOrEqualTo(Long value) {
            addCriterion("update_UserID <=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIn(List<Long> values) {
            addCriterion("update_UserID in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotIn(List<Long> values) {
            addCriterion("update_UserID not in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridBetween(Long value1, Long value2) {
            addCriterion("update_UserID between", value1, value2, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotBetween(Long value1, Long value2) {
            addCriterion("update_UserID not between", value1, value2, "updateUserid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}